| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
| ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
| MerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
| ItemSalesAmount | The cumulative gross Item sales recorded by the RetailStore. The Items are recorded at the various merchandise hierarchy for each ReportingPeriod. | MO_SLS_ITM | Money | decimal(16,5) | |
| ItemSalesUnitCount | The cumulative number of ITEMs sold by the RETAIL STORE. The ITEMs are recorded at the various merchandise hierarchy for each REPORTING PERIOD. | QU_SLS_ITM | QuantityShortCount | decimal(3,0) | |
| ItemSalesTransactionCount | The cumulative number of transactions involving item sales. The item sales are recorded at the various MERCHANDISE HIERARCHY levels for each REPORTING PERIOD. | QU_SLS_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemSalesCostAmount | The cumulative cost of Item sales recorded by the RetailStore. The Items are recorded at the various merchandise hierarchy for each ReportingPeriod. | MO_CST_SLS | MoneyShortCost | decimal(16,5) | |
| ItemReturnAmount | The cumulative monetary value of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | MO_RTN_ITM | Money | decimal(16,5) | |
| ItemReturnUnitCount | The cumulative number of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | QU_RTN_ITM | QuantityShortCount | decimal(3,0) | |
| ItemReturnTransactionCount | The cumulative number of item returns for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | QU_RTN_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemDiscountAmount | The cumulative monetary value of miscellaneous item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | MO_DSC_ITM | Money | decimal(16,5) | |
| ItemDiscountUnitCount | The cumulative number of miscellaneous item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_DSC_ITM | QuantityShortCount | decimal(3,0) | |
| ItemDiscountTransactionCount | The cumulative number of item discounts which have been applied at the transaction level. These discounts will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_DSC_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemEmployeeDiscountAmount | The cumulative monetary value of employee item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | MO_DSC_EM_ITM | Money | decimal(16,5) | |
| ItemEmployeeDiscountUnitCount | The cumulative number of employee item discounts recorded by the RETAIL STORE. These markdowns will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_DSC_EM_ITM | QuantityShortCount | decimal(3,0) | |
| ItemEmployeeDiscountTransactionCount | The cumulative number of item employee discounts which have been applied at the transaction level. These discounts will be recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_DSC_EM_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemStoreCouponAmount | The cumulative monetary value of item store coupons received by the RETAIL STORE. These coupons are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | MO_CPN_STR_ITM | Money | decimal(16,5) | |
| ItemStoreCouponUnitCount | The cumulative number of item store coupons received by the RETAIL STORE. These coupons are recorded at the various hierarchy levels for each REPORTING PERIOD. | QU_CPN_STR_ITM | QuantityShortCount | decimal(3,0) | |
| ItemStoreCouponTransactionCount | The cumulative number of item store coupons received by the RETAIL STORE. These coupons are recorded at the various hierarchy levels for each REPORTING PERIOD. | QU_CPN_STR_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemStoreRefundAmount | The cumulative monetary value of item refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | MO_RFD_STR_ITM | Money | decimal(16,5) | |
| ItemStoreRefundUnitCount | The cumulative number of item refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | QU_RFD_STR_ITM | QuantityShortCount | decimal(3,0) | |
| ItemStoreRefundTransactionCount | The cumulative number of transaction refunds for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | QU_RFD_STR_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemMarkdownAmount | The cumulative monetary value of markdowns recorded by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | MO_MKD_ITM | Money | decimal(16,5) | |
| ItemMarkdownUnitCount | The cumulative number of markdowns recorded by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_MKD_ITM | QuantityShortCount | decimal(3,0) | |
| ItemMarkdownTransactionCount | The cumulative number of transactions which have been marked down by the RETAIL STORE. These markdowns are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_MKD_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemTransactionCount | The cumulative number of transactions for the RETAIL STORE, recorded at the various merchandise hierarchy levels, for each REPORTING PERIOD. | QU_TRN | QuantityTransactionCount | decimal(7,0) | |
| ItemDaysOnPromotionCount | The cumulative number of days where item promotions are run. These days are recorded at the various merchandise hierarchy levels for each REPORTING PERIOD. | QU_DY_PRM_CM | QuantityTransactionCount | decimal(7,0) | |